Window Aggregate
Short Description
The Window Aggregate (WindowAgg) node applies aggregate functions to a SQL window
Detailed Description​
The Window Aggregate node applies aggregate functions to a SQL window. Unlike normal aggregate functions which return one row, WindowAgg returns aggregate values for each of the groups or ranges returned. SQL windows are implemented through the OVER command.
Additional Links​
- PostgreSQL Documentation - Windows Tutorial
- PostgreSQL Documentation - Windows Function Calls
- PostgreSQL Documentation - Using Explain
- pgAnalyze - Explain
- eTutorials - Understanding How PostgreSQL Executes a Query
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.